import numpy as np
import pandas as pd

data_Cplusplus = pd.read_csv(r'D:\bianchengerbianchenger\PyCharm Community Edition 2021.2.3\pythonProject\学习\数据分析\将数据存储到数据库\图片存储处\C++.csv')
data_java = pd.read_csv(r'D:\bianchengerbianchenger\PyCharm Community Edition 2021.2.3\pythonProject\学习\数据分析\将数据存储到数据库\图片存储处\java.csv')
data_web = pd.read_csv(r'D:\bianchengerbianchenger\PyCharm Community Edition 2021.2.3\pythonProject\学习\数据分析\将数据存储到数据库\图片存储处\前端.csv')
data_app_test = pd.read_csv(r'D:\bianchengerbianchenger\PyCharm Community Edition 2021.2.3\pythonProject\学习\数据分析\将数据存储到数据库\图片存储处\软件测试.csv')
data_qianrushi = pd.read_csv(r'D:\bianchengerbianchenger\PyCharm Community Edition 2021.2.3\pythonProject\学习\数据分析\将数据存储到数据库\图片存储处\嵌入式.csv')
data_py = pd.read_csv(r'D:\bianchengerbianchenger\PyCharm Community Edition 2021.2.3\pythonProject\学习\数据分析\将数据存储到数据库\图片存储处\python.csv')

sum_before=np.vstack((data_Cplusplus,data_java,data_web,data_app_test,data_qianrushi,data_py))
print(sum_before)
sum_before=pd.DataFrame(sum_before)
sum_before.to_csv('sum_before.csv')

data_Cplusplus = data_Cplusplus.dropna(axis=0,how='any')
data_java = data_java.dropna(axis=0,how='any')
data_web = data_web.dropna(axis=0,how='any')
data_app_test = data_app_test.dropna(axis=0,how='any')
data_qianrushi = data_qianrushi.dropna(axis=0,how='any')
data_py = data_py.dropna(axis=0,how='any')

sum_after=np.vstack((data_Cplusplus,data_java,data_web,data_app_test,data_qianrushi,data_py))
print(sum_after)
sum_after=pd.DataFrame(sum_after)
sum_after.to_csv('sum_after.csv')

data_Cplusplus.to_csv('C++.csv')
data_java.to_csv('java.csv')
data_web.to_csv('前端.csv')
data_app_test.to_csv('软件测试.csv')
data_qianrushi.to_csv('嵌入式.csv')
data_py.to_csv('python.csv')

